Items Fields

Items Fields

Field

Description and Character Limits

*Item Number

30 characters, alphanumeric.

Item Name

30 character, alphanumeric

Buy

1 character. Any non-blank character signifies that the item is bought.

Sell

1 character. Any non-blank character signifies that the item is sold.

Inventory

1 character. Any non-blank character signifies that the item is inventoried.

Asset Acct

Linked asset account. Must be valid, preexisting MYOB account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

Income Acct

Linked income account. Must be valid, preexisting MYOB account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

Expense/COS Acct

Linked expense or cost of sales account. Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

Item Picture

File name of the graphic. 255 characters, alphanumeric.

Description

255 characters, alphanumeric.

Use Desc. On Invoice

1 character. Any non-blank character signifies that the item description and not the item name should be used on the invoice

Custom List 1-3

30 characters, alphanumeric. Must match an existing list entry.

Custom Field 1-3

30 characters, alphanumeric.

Primary Vendor

31 characters alphanumeric. Must match the name of a vendor card in your card file. (If the vendor is an individual, MYOB AccountEdge matches on the last name, followed by a comma and a space, followed by the first name.)

Vendor Item Number

30 characters alphanumeric.

Tax When Bought

1 character. Any non-blank character signifies that the item is taxable when bought.

Buy Unit Measure

5 characters, alphanumeric.

# Items/Buy Unit

4 characters, numeric.

Reorder Quantity

10 characters, numeric, including 3 decimal places.

Minimum Level

10 characters, numeric, including 3 decimal places.

Selling Price

11 characters, numeric, including 4 decimal places.

Sell Unit Measure

5 characters, alphanumeric.

Tax When Sold

1 character. Any non-blank character signifies that the item is taxable when sold.

# Items/Sell Unit

4 characters, numeric.

Quantity Break 1

This amount, which must be 0.000, is set automatically by MYOB AccountEdge.

Quantity Break 2

10 characters, numeric including 3 decimal places. Must be greater than zero but less than Quantity Break 3.

Quantity Break 3

10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 2 but less than Quantity Break 4.

Quantity Break 4

10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 3 but less than Quantity Break 5.

Quantity Break 5

10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 4.

Price Level A-F,

Qty Break 1

11 characters, numeric including 4 decimal places.

Price Level A-F,

Qty Break 2-5

11 characters, numeric including 4 decimal places. (Price levels are available only when valid quantity breaks have been designated for the item.)

*This is a required field for importing.

Items Fields

Field	Description and Character Limits
*Item Number	30 characters, alphanumeric.
Item Name	30 character, alphanumeric
Buy	1 character. Any non-blank character signifies that the item is bought.
Sell	1 character. Any non-blank character signifies that the item is sold.
Inventory	1 character. Any non-blank character signifies that the item is inventoried.
Asset Acct	Linked asset account. Must be valid, preexisting MYOB account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
Income Acct	Linked income account. Must be valid, preexisting MYOB account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
Expense/COS Acct	Linked expense or cost of sales account. Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
Item Picture	File name of the graphic. 255 characters, alphanumeric.
Description	255 characters, alphanumeric.
Use Desc. On Invoice	1 character. Any non-blank character signifies that the item description and not the item name should be used on the invoice
Custom List 1-3	30 characters, alphanumeric. Must match an existing list entry.
Custom Field 1-3	30 characters, alphanumeric.
Primary Vendor	31 characters alphanumeric. Must match the name of a vendor card in your card file. (If the vendor is an individual, MYOB AccountEdge matches on the last name, followed by a comma and a space, followed by the first name.)
Vendor Item Number	30 characters alphanumeric.
Tax When Bought	1 character. Any non-blank character signifies that the item is taxable when bought.
Buy Unit Measure	5 characters, alphanumeric.
# Items/Buy Unit	4 characters, numeric.
Reorder Quantity	10 characters, numeric, including 3 decimal places.
Minimum Level	10 characters, numeric, including 3 decimal places.
Selling Price	11 characters, numeric, including 4 decimal places.
Sell Unit Measure	5 characters, alphanumeric.
Tax When Sold	1 character. Any non-blank character signifies that the item is taxable when sold.
# Items/Sell Unit	4 characters, numeric.
Quantity Break 1	This amount, which must be 0.000, is set automatically by MYOB AccountEdge.
Quantity Break 2	10 characters, numeric including 3 decimal places. Must be greater than zero but less than Quantity Break 3.
Quantity Break 3	10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 2 but less than Quantity Break 4.
Quantity Break 4	10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 3 but less than Quantity Break 5.
Quantity Break 5	10 characters, numeric including 3 decimal places. Must be greater than Quantity Break 4.
Price Level A-F, Qty Break 1	11 characters, numeric including 4 decimal places.
Price Level A-F, Qty Break 2-5	11 characters, numeric including 4 decimal places. (Price levels are available only when valid quantity breaks have been designated for the item.)